set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
create procedure [dbo].[insertProRoom]
@RoomName nvarchar(50),
@DepartmentID int
as
insert into Room values (@RoomName, @DepartmentID)